[1] "21"
[1] "21.0.5"
#dbWriteTable(con, name=“brighton_sec_schools”, value=brighton_sec_schools, overwrite=TRUE)
[1] "21"
[1] "21.0.5"
Travel Times to Longhill at 7:30 am on 1/12/22 from BN Postcodes
Simple feature collection with 6 features and 16 fields
Geometry type: LINESTRING
Dimension: XY
Bounding box: xmin: -0.1526855 ymin: 50.81938 xmax: -0.063373 ymax: 50.84491
Geodetic CRS: WGS 84
from_id from_lat from_lon to_id to_lat to_lon option departure_time
1 BN1 6ZE 50.84445 -0.152883 114581 50.81901 -0.06729832 1 07:32:02
2 BN1 6ZE 50.84445 -0.152883 114581 50.81901 -0.06729832 1 07:32:02
3 BN1 6ZE 50.84445 -0.152883 114581 50.81901 -0.06729832 1 07:32:02
4 BN1 6ZE 50.84445 -0.152883 114581 50.81901 -0.06729832 1 07:32:02
5 BN1 6ZE 50.84445 -0.152883 114581 50.81901 -0.06729832 1 07:32:02
6 BN1 6ZE 50.84445 -0.152883 114581 50.81901 -0.06729832 1 07:32:02
total_duration total_distance segment mode segment_duration wait distance
1 62.8 10961 1 WALK 7.4 0.0 473
2 62.8 10961 2 BUS 7.4 1.2 2014
3 62.8 10961 3 WALK 0.4 0.0 26
4 62.8 10961 4 BUS 10.0 2.5 1824
5 62.8 10961 5 WALK 2.1 0.0 109
6 62.8 10961 6 BUS 22.9 6.2 6369
route geometry
1 LINESTRING (-0.1522648 50.8...
2 BH:SER5:5 LINESTRING (-0.151085 50.84...
3 LINESTRING (-0.135882 50.83...
4 BH:SER22:22 LINESTRING (-0.1359766 50.8...
5 LINESTRING (-0.113085 50.83...
6 BH:SER2:2 LINESTRING (-0.1128497 50.8...